1 define mw_prefix
='{$wgDBprefix}';
3 ALTER TABLE &mw_prefix.user_groups
ADD (
4 ug_expiry
TIMESTAMP(6) WITH TIME ZONE NULL
6 DROP INDEX IF EXISTS &mw_prefix.user_groups_u01
;
7 ALTER TABLE &mw_prefix.user_groups
ADD CONSTRAINT &mw_prefix.user_groups_pk
PRIMARY KEY (ug_user
,ug_group
);
8 CREATE INDEX &mw_prefix.user_groups_i02
ON &mw_prefix.
user_groups (ug_expiry
);